-- @owner: kyleze
-- @date: 2024-10-20
-- @testpoint: 自定义函数-类型bigint(n)测试，

--prestep1:切换B库;expect:执行成功
@conn PrimaryDbBmode;
show sql_compatibility;

--step1:创建函数  expect:成功
drop function if exists func_bigint_0020;
create or replace function func_bigint_0020(c1 bigint) returns bigint
as  $$
begin
     return c1;
end;
$$ language plpgsql;
/

--step2:调用函数 expect:成功
call func_bigint_0020('000000001');
call func_bigint_0020('');

--step3:清理环境  expect:成功
 drop function  func_bigint_0020;
